FO_Hub_Job_Def_Detail
This table contains the specific Client/Provider/PtLocations to be included on job run when selecting data from tables to use for this job.
| Field | Type | Notes |
|---|---|---|
|
Hub_Job_Def_Detail_ID |
int |
ID field, a counter. Unique |
|
HubCode |
varchar(50) |
Code for HUB |
|
JobID |
varchar(50) |
Enter a unique ID for job. Recommended to establish a naming convention as this will assist in readily identifying jobs. |
|
ClientCode |
varchar(50) |
Defines a list of client codes. Multidimensional pipe delimited field, with leading and trailing pipes. Enter valid client codes separated by pipes. |
|
ProviderCode |
varchar(50) |
Defines a list of provider codes. Multidimensional pipe delimited field, with leading and trailing pipes. Enter valid provider codes separated by pipes. |
|
PtLocationCode |
varchar(50) |
Defines a list of PTLoc, patient location, codes. Multidimensional pipe delimited field, with leading and trailing pipes. Enter valid PTLoc codes separated by pipes. |
|
CreateDate |
datetime |
Date record was created. Informational |
|
EditDate |
datetime |
Date record was last edited. Informational |
|
CreateUser |
varchar(50) |
User who created record. Informational |
|
EditUser |
varchar(50) |
User who last edited record. Informational |